USE [texchange_db]
GO

/****** Object:  UserDefinedFunction [dbo].[Fn_GetAllBanners]    Script Date: 05/29/2011 19:53:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[Fn_GetAllBanners] 
(	
	-- Add the parameters for the function here
)
RETURNS TABLE 
AS
RETURN 
(
	-- Add the SELECT statement with parameter references here
	SELECT TOP 100 id, link, position, [filename], isActive, _order FROM Banners ORDER By _order asc
)

GO


